We couldn't find a name column
Make sure your spreadsheet's header row has either one column for names ("Name"), or two columns for names ("First" and "Last"). Your spreadsheet must have either a single "Name" column, or both "First" and "Last" columns.
For an example of what the header row should look like, please
view the example spreadsheet.
We couldn't find a first name column
We found a column for last names, but not a column for first names (or a column for full names).
Make sure your spreadsheet's header row has either one column for names ("Name"), or two columns for names ("First" and "Last"). Your spreadsheet must have either a single "Name" column, or both "First" and "Last" columns.
For an example of what the header row should look like, please
view the example spreadsheet.
We couldn't find a last name column
We found a column for first names, but not a column for last names (or a column for full names).
Make sure your spreadsheet's header row has either one column for names ("Name"), or two columns for names ("First" and "Last"). Your spreadsheet must have either a single "Name" column, or both "First" and "Last" columns.
For an example of what the header row should look like, please
view the example spreadsheet.
We couldn't find two columns
The spreadsheet is missing
several columns that you selected to import:
Make sure there aren't any typos in your header row. Your column headers must match the field names displayed above.
To change which columns to import,
go back to column setup. Alternatively,
skip the missing column(s).
If your spreadsheet has multiple sheets within in, then make sure you selected the correct sheet to import from. We read from the sheet named "
".
Go back and change sheet
We found the "Flex" column more than once
The spreadsheet has
several duplicate columns:
Make sure all of your columns are labeled correctly in the header row. Rename any columns that are being misidentified.
To change which columns to import,
go back to column setup.
If your spreadsheet has multiple sheets within in, then make sure you selected the correct sheet to import from. We read from the sheet named "
".
Go back and change sheet
A column header contained multiple field names
The spreadsheet has
several columns with
it was more than one field name, so we couldn't figure out which
field it was supposed to be.
Make sure all of your columns are labeled correctly in the header row. Rename any columns with names that contain more than one field name so that we can tell which fields they're supposed to be.
To change which columns to import,
go back to column setup.
If your spreadsheet has multiple sheets within in, then make sure you selected the correct sheet to import from. We read from the sheet named "
".
Go back and change sheet
We had to skip 3 people with duplicate names
We skipped all instances of
3 names in the spreadsheet because
they appeared on more than one row:
Two contacts can't have the same name. If two people have the same name, add a middle initial to their names to differentiate between them.
We had to skip 3 people
We skipped
3 rows in the spreadsheet due to
missing or invalid values:
Make sure each row of the spreadsheet has at least a name, category, and position.
Go back to column setup instructions
Your spreadsheet contains one or more categories that don't exist. Categories must be created in the Dashboard before they can be used in a spreadsheet. Here's your current list of categories:
Tip: Use data validation in Google Sheets or Excel to create a dropdown that lets you select from your list of categories.
Video tutorial
We found a name with more than one comma
The spreadsheet has
several names with more than one comma:
We didn't find both a "First" and "Last" column in your spreadsheet, so we're using one column for names. Names can either be "First Last" or "Last, First". Names shouldn't have more than one comma, because that doesn't make sense.
We had to skip 3 invalid emails
We skipped
3 emails in the spreadsheet because
they were invalid:
Make sure all the emails are valid. Enter the full email address, such as "
[email protected]".
Make sure we identified the right column for email addresses. We thought column
B was the Email column.
Go back to column setup
We had to skip 3 invalid phone numbers
We skipped
3 phone numbers in the spreadsheet because
they were invalid:
Make sure all the phone numbers are valid. Supports extensions. Example: "555-432-4010 ext. 153". Enter the full phone number; providing just an extension won't work. Don't include the country code prefix (+1).
Make sure we identified the right column for phone numbers. We thought column
B was the Phone column.
Go back to column setup
We had to skip 3 invalid website
We skipped
3 websites in the spreadsheet because
they were invalid:
Make sure all the websites are valid. Enter a website URL, such as "byermath.blogspot.com".
Make sure we identified the right column for websites. We thought column
B was the Website column.
Go back to column setup